package servlet;

import util.JdbcUtil;

import javax.servlet.*;
import javax.servlet.http.*;
import javax.servlet.annotation.*;
import java.io.IOException;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

public class SupplierUpdateServlet extends HttpServlet {
    @Override
    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
         doPost(request,response);
    }

    @Override
    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        int sid= Integer.parseInt(request.getParameter("sid"));
        String name =request.getParameter("name");
        String person =request.getParameter("person");
        String tel =request.getParameter("tel");
        String address =request.getParameter("address");
        String email =request.getParameter("email");
        String sql ="UPDATE supplier set `name`=?,person=?,tel=?,address=?,email=? WHERE sid=?";
        try {
         PreparedStatement ps = JdbcUtil.getConnection().prepareStatement(sql);

            ps.setString(1, name);
            ps.setString(2, person);
            ps.setString(3, tel);
            ps.setString(4, address);
            ps.setString(5, email);
            ps.setInt(6, sid);
            ps.executeUpdate();
            request.getRequestDispatcher("supplier.jsp").forward(request, response);
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
}
